package com.city.repository.party;

import com.city.domain.party.PartyFaboradFamily;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @deprecation: 干部出国，国内外家属登记
 * @dmail: 398521613@qq.com
 * @author: L-H
 * @date: 2018-07-18 13:14
 */
public interface PartyFaboradFamilyRepository extends JpaRepository<PartyFaboradFamily,Integer> {
        //通过abroadId和国内国外查询查询查询
    @Query(value = "select * from party_faborad_family where faborad_id = ?1 and domestic_aborad = ?2",nativeQuery = true)
    List<PartyFaboradFamily> findByAbroadId(String abroadId,String type);


}
